Computer Science for IGCSE & O level - Databases (Section 5 - No. 19)
What does the `ON DELETE CASCADE` constraint do in a foreign key relationship?
Prevents the deletion of parent records.
Automatically deletes related child records when a parent record is deleted.
Updates the primary key of the child table when the parent key changes.
Allows the deletion of parent records but leaves the child records untouched.
Giải thích
`ON DELETE CASCADE` automatically deletes related child records if the corresponding parent record is deleted.